﻿USE CORINA_PROD
GO

CREATE TABLE t_device_sale (
    Id INT PRIMARY KEY IDENTITY,
    DeviceSn VARCHAR(50),
    SaleDate DATETIME DEFAULT(GETDATE()),
    Price FLOAT DEFAULT(0),
    Salesperson VARCHAR(50),
    UserId INT DEFAULT(0)
)